netsqlazman_AuthorizationsTable

EntityType | Independent
Logical Entity Name | netsqlazman_AuthorizationsTable
Default Table Name | netsqlazman_AuthorizationsTable
Logical Only | NO
Owner | dbo
Definition |
Note |

netsqlazman_AuthorizationsTable Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
AuthorizationId |  | INTEGER | NO |
ItemId |  | INTEGER | NO |
ownerSid |  | VARBINARY/BLOB(85) | NO |
ownerSidWhereDefined |  | TINYINT | NO |
objectSid |  | VARBINARY/BLOB(85) | NO |
objectSidWhereDefined |  | TINYINT | NO |
AuthorizationType |  | TINYINT | NO |
ValidFrom |  | DATETIME | YES |
ValidTo |  | DATETIME | YES |

netsqlazman_AuthorizationsTable Keys

Key Name | Key Type | Keys
IX_Authorizations_1 | Inversion Entry | ItemId, objectSid, objectSidWhereDefined, AuthorizationType, ValidFrom, ValidTo
IX_Authorizations | Inversion Entry | ItemId, objectSid
PK_Authorizations | PrimaryKey | AuthorizationId

netsqlazman_AuthorizationsTable Relationships

Parent Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype
netsqlazman_ItemsTable | Non-Identifying | One To Zero or More |  |  |  | ItemId | NO

Child Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype
netsqlazman_AuthorizationAttributesTable | Non-Identifying | One To Zero or More |  |  |  |  | NO

netsqlazman_AuthorizationsTable Check Constraints

Check Constraint Name | CheckConstraint
CK_ValidFromToCheck | ([ValidFrom] IS NULL OR [ValidTo] IS NULL OR [ValidFrom]<=[ValidTo])

netsqlazman_AuthorizationsTable Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.netsqlazman_AuthorizationsTable | NO |  |  |
Physical (Microsoft SQL Server) dbo.netsqlazman_AuthorizationsTable | NO |  |  |

netsqlazman_AuthorizationsTable Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | NetSqlAzman

netsqlazman_AuthorizationsTable Data Movement Rules

Name | Type | Rule Text/Value